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