UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kTzVYR+7SecL3k3jWf33kVZpRNInue+JiDPZoHKDqDU='
WHERE
key_id = '6afb9e88007073f1e612eae83ee0a9d5b99d266aae15af816a0ac45d40512de0'
AND (
token = 'kTzVYR+7SecL3k3jWf33kVZpRNInue+JiDPZoHKDqDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)