UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zn0aJBJB3X9DGKpi12xgkoh8/5qHSZstHBHAnBlMxgk='
WHERE
key_id = '332f4363c43bfdf5729ee842a825f4aa570963ea563b78c4aeb3ba466d674885'
AND (
token = 'zn0aJBJB3X9DGKpi12xgkoh8/5qHSZstHBHAnBlMxgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)