UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c9Uaanu4070BfLJ32tr6t4spIVxvIlbwNLjJYpBFc68='
WHERE
key_id = 'd68c5b8c485453458a65032f691dc6804cdc2242cf42d7950b20c75334d4e192'
AND (
token = 'c9Uaanu4070BfLJ32tr6t4spIVxvIlbwNLjJYpBFc68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)