UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gvuu4INrCvZB9CYjQ95X/kcW2huE7EafxaEC8aXkTv8='
WHERE
key_id = '6bc14049c509c4501999896697fbabc5d1b51a62a81d484ade550817a5f3d95c'
AND (
token = 'Gvuu4INrCvZB9CYjQ95X/kcW2huE7EafxaEC8aXkTv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)