UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z18WVCSdbTmTZBrvQ9DTd2A/I2yFwfBwR5Kp12469Ds='
WHERE
key_id = '6fc7efa20764f040896434f8fddc9ce9d652a7f8ba5b0e861fc4c7855dbf8383'
AND (
token = 'z18WVCSdbTmTZBrvQ9DTd2A/I2yFwfBwR5Kp12469Ds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)