UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y1RHqCDYDfokM7R/OGsWZYwXKFvjM2OgjBQHc0JK2Ro='
WHERE
key_id = 'ae22f3297ec9f11230582f56d2a9f383541378ed9ac47757e16062b4302a2822'
AND (
token = 'y1RHqCDYDfokM7R/OGsWZYwXKFvjM2OgjBQHc0JK2Ro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)