UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K7fa7qsm+alzS7AghbZJ6ptkYYkaurJPCW1ABP9AbKA='
WHERE
key_id = 'dec1cd478e9f4a71c12f141c2d2338e6b62c53b88f7c5a53c3f0dea1c246b333'
AND (
token = 'K7fa7qsm+alzS7AghbZJ6ptkYYkaurJPCW1ABP9AbKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)