UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WNuz7I8Exc1drVsW+4ht3dqAnlc95oj0mKfZ6wfm2Fw='
WHERE
key_id = 'bf6549a7001dc3058183afe142a9eeba77f718dba80bc2822b74567d6a89e1d9'
AND (
token = 'WNuz7I8Exc1drVsW+4ht3dqAnlc95oj0mKfZ6wfm2Fw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)