UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PrUr9vW1i+KkAO28i6CMNFsKE2CO8YKxkc3bAFLap54='
WHERE
key_id = '6a9ab0d0e4f2d42c90a0542ccefedc664b671a03c8a4566e8157ca8ce6d30255'
AND (
token = 'PrUr9vW1i+KkAO28i6CMNFsKE2CO8YKxkc3bAFLap54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)