UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RNV4OdR1EKi+toPWl+dLzuLCEiLikvsIDpseK7f/3AU='
WHERE
key_id = '7a0321b5c6fb1ddf07a26d5f5ad7592a98c4c812fb1214d5b16e96c00b375289'
AND (
token = 'RNV4OdR1EKi+toPWl+dLzuLCEiLikvsIDpseK7f/3AU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)