UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aESkU0UrW1VqgZGJNTN3Gb8tVkfxx8UuKjeGia9KL3s='
WHERE
key_id = '427d350e0688fa5718bf0a98e3be1b5adc4785b2241b87663f12553379f6bc2e'
AND (
token = 'aESkU0UrW1VqgZGJNTN3Gb8tVkfxx8UuKjeGia9KL3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)