UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zUiJ3LwqvNcAZ0D30yVUKhO6GY1jZWsUUYxCUanKVNc='
WHERE
key_id = '0596001fa38c8a485636263bb51d51c1beb4fc9a36b27a1fb182e8aef3cb01c7'
AND (
token = 'zUiJ3LwqvNcAZ0D30yVUKhO6GY1jZWsUUYxCUanKVNc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)