UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ia8rydU33jil7aG6UhNzyiNlLtMP7SRwA4QRFoWU+h4='
WHERE
key_id = '857b9cc284c81b2495c76c33b418326e7a522c9095fe0fd870e92800ce1b3010'
AND (
token = 'ia8rydU33jil7aG6UhNzyiNlLtMP7SRwA4QRFoWU+h4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)