UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ti/UV7FnBZ6DA4Vn0iMJ2XFeKJrVpH1eMownz1V2NM='
WHERE
key_id = '78198e0f9c97e8f88b99cd210139df865350c7250a4c5485e13abde96a62d4d7'
AND (
token = '9ti/UV7FnBZ6DA4Vn0iMJ2XFeKJrVpH1eMownz1V2NM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)