UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b3NjrOJnHsw9L3jXI1XtKRt0m3FU79qZazPNm5VsPS8='
WHERE
key_id = '1611ccadd516e10f8ed30094e0b919b1e215b86417a35a65904aaee57e9d3383'
AND (
token = 'b3NjrOJnHsw9L3jXI1XtKRt0m3FU79qZazPNm5VsPS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)