UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vTM91PYwmHqIuwOlgnHSuugrpLVQHniR4F2m8X5msGQ='
WHERE
key_id = 'f99b30e7f4d67c083aa6120b818f1dde5eced1496e8f7de3acd6cf0cb76e0498'
AND (
token = 'vTM91PYwmHqIuwOlgnHSuugrpLVQHniR4F2m8X5msGQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)