UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5toE7yXt13nDYbpwFnClHabikNXIID1PdDQh+/AH3cw='
WHERE
key_id = 'd74b43a14f84da84ebbef0020cf44454cd10e041b0784bee6d0ea28c9562c101'
AND (
token = '5toE7yXt13nDYbpwFnClHabikNXIID1PdDQh+/AH3cw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)