UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6K2/jr8IXqqwsl/r6H4R59/WFhiHAOQOd0y06a4XqB0='
WHERE
key_id = 'e80a981f5ef3e7081c2ce66834f94a8563f3367945533a1a4437efd95a0fba86'
AND (
token = '6K2/jr8IXqqwsl/r6H4R59/WFhiHAOQOd0y06a4XqB0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)