UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vl7QG9WE6hr2d0SAx94eTA/SVBHLSE5sKQWzNLd5qWg='
WHERE
key_id = '6ea57c7ee396790031f90b4328bed3a6330bd1dbcf5e32914f3bdb0e3af2b526'
AND (
token = 'vl7QG9WE6hr2d0SAx94eTA/SVBHLSE5sKQWzNLd5qWg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)