UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnPjcg1/Aij/QXKgIp+QAm7GBFKmQfZxT0zyLKAMCsA='
WHERE
key_id = 'a429e23fe64d9107d32f7e18507e194bb5e42527162269d661fe89d0d0f35a0a'
AND (
token = 'ZnPjcg1/Aij/QXKgIp+QAm7GBFKmQfZxT0zyLKAMCsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)