UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X3wvveZw4LT7bxtlTMGiE3lbdR06GfM1zGZvJDcnaF8='
WHERE
key_id = '792a01847e1928f63a66d075de5bf6aca4340d9115c1f90fa4ff0b78400a6d5b'
AND (
token = 'X3wvveZw4LT7bxtlTMGiE3lbdR06GfM1zGZvJDcnaF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)