UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ml7PJfhe8/Xmi67kcLAHpxdAGIFq/TmhV20xMNGCJE8='
WHERE
key_id = '299e02005450d66548e8e5bc53874b98ebef3ca0bb3da98e4124880d2cf3783c'
AND (
token = 'ml7PJfhe8/Xmi67kcLAHpxdAGIFq/TmhV20xMNGCJE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)