UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Kh4RvVY5awJGGLPNSJdqcwfbK6lmSqIrPuzWW6J1wDs='
WHERE
key_id = 'e1ecbd443c6e0047b1cafd4bc649549ffe27f810f4b7ad8c7adb714db58e8226'
AND (
token = 'Kh4RvVY5awJGGLPNSJdqcwfbK6lmSqIrPuzWW6J1wDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)