UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2eiVibFrom+wtzxWAxpJqModiyqthqY+KUJa2+iCUpI='
WHERE
key_id = 'ff7e3727854a1dc0a21547d40df5ca9fceb512be2283adbad813fe5c5c156631'
AND (
token = '2eiVibFrom+wtzxWAxpJqModiyqthqY+KUJa2+iCUpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)