UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KCdUGtM04SqCzDw+9PxoxVlUioKkzYBy7qfV+D39a4w='
WHERE
key_id = 'b45e7abf4816bedbfb2e9a1f7947aa746a8623c50e8a1c7cad7b18429f8de3f2'
AND (
token = 'KCdUGtM04SqCzDw+9PxoxVlUioKkzYBy7qfV+D39a4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)