UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4KY5Hihj0436Cdr4iXo3VodcIA7oYgE0FQnBM5TNMbo='
WHERE
key_id = 'ed17ca9e88b2c061bb5a825a8f55e4d300ecf9b9a7650b6b3b21025e402834a1'
AND (
token = '4KY5Hihj0436Cdr4iXo3VodcIA7oYgE0FQnBM5TNMbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)