UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7I0IhpHj1OOJY3U18WigAnBoDQy8193Td74okgqTv8s='
WHERE
key_id = '8059ddfd1e2053fc580aa7b11d90c9412b8829eaf3bd50d84cdb4a6f78eb577c'
AND (
token = '7I0IhpHj1OOJY3U18WigAnBoDQy8193Td74okgqTv8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)