UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RTpGzSgmnYtRWD1NB2JqNK7Llya4MvpDcDSCCV16+O0='
WHERE
key_id = 'e51e3a796c0ae20a471963467fc76f3040dcd3d4e5b0a0761db0c7d989a8ff08'
AND (
token = 'RTpGzSgmnYtRWD1NB2JqNK7Llya4MvpDcDSCCV16+O0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)