UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Ns8d+KvCo9WY2TUv21rf6381baVIrXT88+wJiirdcE='
WHERE
key_id = '2f057018043c7bbf2467af4032c4bff0f1f254d87fa3027be6d70465fa597d3b'
AND (
token = '1Ns8d+KvCo9WY2TUv21rf6381baVIrXT88+wJiirdcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)