UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/wj8Pj6s9oucdnaJsHDRDxA26uGF/WkpLWvGqvmjmKw='
WHERE
key_id = '1e722e5c5ca09bf58e24f6e5e7c927f6f9f073a08313507672b4485edea15037'
AND (
token = '/wj8Pj6s9oucdnaJsHDRDxA26uGF/WkpLWvGqvmjmKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)