UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HWiN/y2vbLmvm8ZRKMvdL8v5lbCZlfsgminQadDaGiw='
WHERE
key_id = 'e1e03aab16daf8b5ad2cc81c5b76d9de3a0c87eabcf4982200a7ebe68cd70068'
AND (
token = 'HWiN/y2vbLmvm8ZRKMvdL8v5lbCZlfsgminQadDaGiw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)