UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TdOrQZ7bSFjm9vXWaIi4j4jh0pfrVYZRrolF6inBmYA='
WHERE
key_id = '67f527072f4ffd174a0b5e187d728aeb45efa1685d7bda45ca68f30781477c8c'
AND (
token = 'TdOrQZ7bSFjm9vXWaIi4j4jh0pfrVYZRrolF6inBmYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)